In any of our document libraries (SharePoint 2007 SP1), if I run "Manage checked out files" (from Document Library Settings), the page spins for several minutes and then crashes.In the trace log, we see that proc_GetListCheckedOutFiles timed out. Any ideas why this would happen?06/02/2009 17:19:12.83 w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services Database 880mHigh SqlCommand: 'proc_GetListCheckedOutFiles' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@SiteId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '8d0b2212-aece-4a3f-82c0-13f89351405f' Parameter: '@ListUrl' Type: NVarChar Size: 26 Direction: Input Value: '/sites/marketing/Documents' 06/02/2009 17:19:12.86 w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services General 8dzzHigh Exception Type: System.Web.HttpException Exception Message: Request timed out. 06/02/2009 17:19:12.76 w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services Database 880iHigh System.Threading.ThreadAbortException: Thread was being aborted. at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 ) at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data... 06/02/2009 17:19:12.76*w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services Database 880iHigh ....SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehav... 06/02/2009 17:19:12.76*w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services Database 880iHigh ...ior behavior) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior) 06/02/2009 17:19:12.76 w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services Database 880kHigh at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command) at Microsoft.SharePoint.SPDocumentLibrary.get_CheckedOutFiles() at Microsoft.SharePoint.ApplicationPages.ManageCheckedOutFilesPage.PrepareContent() at Microsoft.SharePoint.ApplicationPages.ManageCheckedOutFilesPage.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP._layouts_managecheckedoutfiles_aspx.ProcessRequest(HttpContext context... 06/02/2009 17:19:12.76*w3wp.exe (0x05C8) 0x0F50Windows SharePoint Services Database 880kHigh ...) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

Looks like this is crashing only for large document libraries. We have a few small ones where the operation runs quickly (a few seconds at most). The crashing libraries have tens of thousands of documents in them.

You do know that list performance drops considerably with over 2000 items, right? A way around it isto break them up into folders.http://blogs.msdn.com/sharepoint/archive/2007/07/25/scaling-large-lists.aspxIt does seem that a lot of your files are big in size and you might want to consider using links to document shares for your SharePoint site to avoid certain issues that you are having (e.g. 40mb+ text files). http://www.lcbridge.nl/vision/2008/largefiles.htmThat's SharePoint for you...

DueNorth: We are using folders. I don't think any of our folders have more than a few hundred items.The average document size is under 1 megabyte. But we do have critical files that are larger. Thanks for the link.Using "links to document shares" unfortunately eliminates all the advantages of SharePoint, and adds the extra burden of maintaining the link and the file separately.

Dbturtle,How did you resolve it? Because I have the same problem in WSS 3.0. There are 2 document libraries where the "manage checked out files" page crashes.

Unfortunately, it isn't resolved. I'm guessing the SQL query can't handle larger document libraries, which would make this a SharePoint bug.

you can resolve this. you will have to analyze the sql server to see which table requires indexing. In WSS 3.0 I was not able to get a library working with over 5000 documents until i broke it up into files.